{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Nov 13 Non Calculator"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Nov 13 Non Calculator","index":0,"n_rows":40,"n_cols":36,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,31,7,31],[6,32,7,32],[0,0,0,24]]}
["Nov 13 Non Calculator"]
[null,"q1","q2","q3","q4","q5a","q5b","q6a","q6b","q7","q8","q9","q10","q11","q12","q13","q14a","q14b","q14c","q15","q16","q17","q18 and c","q18b","q19","q20a","q20b","q21","q22","q23","q24"]
[null,"Proportion Recipe Questions","Scatter Graphs","Fundamental Algebra","Expanding and Factorising","Probability","Probability and Relative Frequency","Translations ","Rotations","Worded LCM Questions","Forming and Solving Equations","Questionairres","Area of Compound Shapes","Functional Maths Questions","Drawing Straight Line Graphs","Missing Mean Questions","Reciprical","Fractional & Negative Indices","Standard Form","Simultaneous Equations","Similar Shapes","3d Midpoint","Cumulative Frequency","Reasoning","Tree Diagrams","Solving Equations ","Algebraic Fractions","Proportionality","Circle Theorems","Negative Scale Factor","Vectors"]
["Max Mark",3,4,4,7,1,2,1,3,4,5,4,5,5,4,3,1,1,2,4,3,2,4,3,3,3,3,4,4,2,6]
["Class Average (%)",{"$f":"AVERAGE(B9:B40)/B4","v":0.55952380952380953},0.5803571428571429,0.48214285714285715,0.42857142857142855,0.39285714285714285,0.5178571428571429,0.5,0.47619047619047622,0.625,0.55714285714285716,0.42857142857142855,0.52857142857142858,0.4642857142857143,0.39285714285714285,0.46428571428571425,0.39285714285714285,0.5,0.44642857142857145,0.45535714285714285,0.5714285714285714,0.5,0.5446428571428571,0.52380952380952384,0.51190476190476197,{"$f":"AVERAGE(Z9:Z40)/Z4","v":0.5714285714285714},0.47619047619047622,0.5267857142857143,0.48214285714285715,0.39285714285714285,0.43452380952380953]
["Standard Deviation",{"$f":"IF(COUNT(B9:B36)<2,\"\",STDEV(B9:B40)/B4)","v":0.30162210882402524},0.30469756885411553,0.33972055120356337,0.31104631654389564,0.49734746139343805,0.37223406756797672,0.50917507721731559,0.30669580415215741,0.27638539919628335,0.27945525240230878,0.30320161103004867,0.30894940597084081,0.30817778144042929,0.34311057652725852,0.29171390396014457,0.49734746139343805,0.50917507721731559,0.3426283407632531,0.32669480766381542,0.26999684279731367,0.3042903097250923,0.32669480766381542,0.33245032957470921,0.34524569717349646,{"$f":"IF(COUNT(Z9:Z36)<2,\"\",STDEV(Z9:Z40)/Z4)","v":0.31239342685979915},0.24726606233963855,0.32159387283905,0.31862385978009244,0.31497039417435602,0.26581378160339958]
[null,"q1","q2","q3","q4","q5a","q5b","q6a","q6b","q7","q8","q9","q10","q11","q12","q13","q14a","q14b","q14c","q15","q16","q17","q18a and c","q18b","q19","q20a","q20b","q21","q22","q23","q24","Total Marks","Grade"]
["Name"]
["Sample student 1",{"$f":"ROUND(RAND()*B$4,0)","v":3},{"$f":"ROUND(RAND()*C$4,0)","v":3},3,5,1,1,0,2,2,1,1,5,1,3,1,1,0,1,4,2,0,3,2,0,1,2,2,2,1,1,{"$f":"IF(AE9=\"\",\"\",SUM(B9:AE9))","v":54},{"$f":"IF(AF9=\"\",\"\",VLOOKUP(AF9,$AI$13:$AJ$34,2))","v":"B3"}]
["Sample student 2",{"$f":"ROUND(RAND()*B$4,0)","v":1},4,3,1,0,1,0,2,3,5,1,2,2,0,2,0,1,1,3,0,0,2,2,1,1,2,3,2,1,3,{"$f":"IF(AE10=\"\",\"\",SUM(B10:AE10))","v":49},{"$f":"IF(AF10=\"\",\"\",VLOOKUP(AF10,$AI$13:$AJ$34,2))","v":"C1"},null,"Grade Boundaries"]
["Sample student 3",1,3,4,6,0,0,1,2,1,3,1,4,3,2,3,0,1,0,0,2,1,4,2,2,1,1,0,2,0,2,52,"B3"]
["Sample student 4",0,2,1,7,0,1,1,2,3,3,2,1,0,0,1,0,0,0,1,2,1,2,3,1,2,1,2,3,1,6,49,"C1",null,"Non- Calc"]
["Sample student 5",2,3,4,1,0,1,0,2,2,1,2,1,0,2,1,0,1,1,0,2,1,3,0,3,3,1,2,1,0,3,43,"C2",null,0,"F3"]
["Sample student 6",2,1,1,0,0,2,0,2,0,3,4,3,1,2,1,0,1,0,0,3,1,1,0,0,2,2,4,4,2,0,42,"C2",null,2.3333333333333335,"F2"]
["Sample student 7",2,2,4,4,0,1,1,1,3,2,1,3,4,1,2,1,0,0,3,1,1,4,3,3,0,1,3,0,0,3,54,"B3",null,4.666666666666667,"F1"]
["Sample student 8",3,4,3,2,1,1,0,2,1,4,1,5,0,3,2,0,0,1,2,1,2,2,0,2,1,3,3,2,1,5,57,"B3",null,7,"E3"]
["Sample student 9",1,2,0,1,0,2,0,1,3,3,1,3,3,1,2,0,1,1,4,2,2,2,1,1,{"$f":"ROUND(RAND()*Z$4,0)","v":2},1,3,0,1,0,44,"C2",null,10,"E2"]
["Sample student 10",3,3,2,6,1,0,1,1,4,0,1,0,4,1,2,0,{"$f":"ROUND(RAND()*R$4,0)","v":0},1,3,2,1,0,1,0,1,1,2,4,2,4,51,"B3",null,13,"E1"]
["Sample student 11",2,2,2,6,1,0,0,2,4,3,2,4,0,1,1,0,0,2,1,2,1,4,2,1,1,2,2,2,1,2,53,"B3",null,16,"D3"]
["Sample student 12",2,3,1,4,1,1,1,2,1,3,1,3,3,0,2,1,0,2,0,2,0,2,1,0,1,1,4,2,1,1,46,"C1",null,21.666666666666668,"D2"]
["Sample student 13",3,3,4,4,1,1,1,0,2,1,4,5,3,3,1,1,1,0,1,1,2,1,2,1,3,1,1,2,1,1,55,"B3",null,27.333333333333336,"D1"]
["Sample student 14",1,0,3,1,0,1,0,0,2,3,1,4,4,2,1,1,0,1,2,2,1,2,2,1,2,1,1,4,0,2,45,"C1",null,33,"C3"]
["Sample student 15",2,3,2,5,0,0,1,1,3,4,0,1,4,3,2,0,1,0,1,3,1,3,3,0,1,2,1,3,1,2,53,"B3",null,39,"C2"]
["Sample student 16",3,3,0,4,0,0,0,3,2,4,4,4,4,3,1,0,1,0,3,1,1,4,3,1,1,0,1,2,0,4,57,"B3",null,45,"C1"]
["Sample student 17",2,4,1,4,1,2,0,0,1,3,3,4,4,0,1,1,0,1,0,0,1,4,2,2,1,2,1,1,1,5,52,"B3",null,51,"B3"]
["Sample student 18",0,3,1,4,1,2,1,0,4,4,0,3,0,2,1,1,0,1,1,1,1,3,3,3,1,2,0,1,1,2,47,"C1",null,57.333333333333336,"B2"]
["Sample student 19",1,3,3,4,1,1,0,1,3,5,1,1,3,0,0,1,0,1,3,2,1,1,1,2,1,1,4,1,2,3,51,"B3",null,63.666666666666664,"B1"]
["Sample student 20",1,2,0,1,0,2,1,3,3,2,1,1,1,3,1,1,1,2,2,2,1,3,1,1,1,1,0,1,1,5,45,"C1",null,70,"A3"]
["Sample student 21",1,2,0,0,0,2,0,1,3,5,2,2,2,0,1,1,1,2,1,1,1,1,0,3,3,1,2,3,1,2,44,"C2",null,75,"A2"]
["Sample student 22",1,1,2,6,0,2,0,2,1,1,3,0,4,4,2,0,1,2,2,3,0,0,1,2,1,3,3,1,0,2,50,"C1",null,80,"A1"]
["Sample student 23",3,0,0,1,1,0,0,2,4,3,1,0,1,0,2,0,1,1,3,2,1,0,2,3,3,1,3,0,1,1,40,"C2",null,85," A*3"]
["Sample student 24",1,1,1,3,0,1,1,0,3,1,0,4,2,0,0,1,1,1,1,1,2,2,1,2,3,2,4,0,0,3,42,"C2",null,90,"A*2"]
["Sample student 25",2,4,1,1,1,1,1,{"$f":"ROUND(RAND()*I$4,0)","v":2},2,4,3,3,4,4,3,0,0,1,4,1,0,3,1,1,3,1,2,3,0,1,57,"B3",null,95,"A*1"]
["Sample student 26",{"$f":"ROUND(RAND()*B$4,0)","v":1},0,3,1,0,0,1,2,3,2,3,3,4,1,0,0,0,0,3,2,2,0,1,2,3,0,3,4,1,3,48,"C1",null,100,"A*1"]
["Sample student 27",2,1,3,0,0,1,1,0,3,4,1,3,1,3,3,0,1,1,1,2,1,3,1,2,3,2,0,1,1,5,50,"C1"]
["Sample student 28",1,3,2,2,0,2,1,2,4,1,3,2,3,0,0,0,0,1,2,3,1,2,3,3,2,2,3,3,0,2,53,"B3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]